package com.sacfa.commons.sql;

public class ColoniaSQL {
	public static final String SELECT_ONE;
	public static final String SELECT_FOR_MUNICIPIO;
    public static final String SELECT_ALL;
    
    static {
        StringBuilder qryBuilder = new StringBuilder();

        qryBuilder.append("SELECT * FROM Colonia WHERE Descripcion = ?");
        SELECT_ONE = qryBuilder.toString();

        qryBuilder = new StringBuilder();
        qryBuilder.append("SELECT * FROM Colonia WHERE Municipio = ? ORDER BY Descripcion");
        SELECT_FOR_MUNICIPIO = qryBuilder.toString();
        
        qryBuilder = new StringBuilder();
        qryBuilder.append("SELECT * FROM Colonia");
        SELECT_ALL = qryBuilder.toString();
    }
}
